Database Changes for 4.37

This section contains details of database changes between the 4.36 and 4.37 releases.

Table changes:

The following tables have been added.

Table Name Description
PEOPLE_PEOPLE_LINKS_HISTORY Holds history of relationships between people.
PEOPLE_UNITS_SPECIAL_HESA_FIN Financial support received by a student which is different from other students studying on the same course who are also included in the return.

The following columns have been added.

Table Name Column Name Type (Size) Nullable Description
ELWA_ERR_LOGS EMPLOYER_CONTACT_ID NUMBER(10) Y The Employer Contact with an error.
ELWA_ERR_LOGS EMPLOYER_ID NUMBER(10) Y The Employer with an error, associated to ORGANISATION_UNITS.ID.
ELWA_ERR_LOGS EMPLOYMENT_PERIOD_ID NUMBER(10) Y The Employment Period with an error, associated to ORG_UNIT_PEOPLE.ID.
ELWA_ERR_LOGS SUSPENSION_ID NUMBER(10) Y The Suspension with an error, associated to LLWR_SUSPENSIONS.ID.
ELWA_ERR_LOGS SUS_ID VARCHAR2(2) Y The Suspension ID provided by DCELLS.
ELWA_RUN_DETAILS EC_FILENAME VARCHAR2(25) Y Employer Contact output filename.
ELWA_RUN_DETAILS EC_RECORD_TOT NUMBER(6) Y Employer Contact records count.
ELWA_RUN_DETAILS EM_FILENAME VARCHAR2(25) Y Employer output filename.
ELWA_RUN_DETAILS EM_RECORD_TOT NUMBER(6) Y Employer records count.
ELWA_RUN_DETAILS EP_FILENAME VARCHAR2(25) Y Employment Period output filename.
ELWA_RUN_DETAILS EP_RECORD_TOT NUMBER(6) Y Employment Period records count.
ELWA_RUN_DETAILS SUS_FILENAME VARCHAR2(25) Y Suspension output filename.
ELWA_RUN_DETAILS SUS_RECORD_TOT NUMBER(6) Y Suspension records count.
ILP_TARGETS TARGET_OWNER NUMBER(10) Y The staff member who has ownership of this target [FK=PEOPLE.PERSON_CODE].
PEOPLE_PEOPLE_LINKS HAS_PERMISSION VARCHAR2(1) N The indicator when the learner has given permission to a contact (Y/N) [DEFAULT=N].
PEOPLE_UNITS_CDR PROG_PATHWAY_DATE DATE Y Populated if the programme pathway is Introductory or Referral. If Introductory, the date the learner has completed the introductory phase and commences on the full Traineeship. If Referral, the date the learner commences the Level 1 course.

Back to top

The following columns have been changed.

Table Name Column Name Type (Size) Nullable Previous Values Type (Size) [Nullable]
ILP_QUESTION_DEFINITIONS NAME VARCHAR2(800) N VARCHAR2(140)[N]
ILP_QUESTION_SNAPSHOTS NAME VARCHAR2(800) N VARCHAR2(140)[N]
PEOPLE_UNITS_CDR PROG_FAST_TRACK VARCHAR2(2) Y VARCHAR2(1)[Y]
UI_HESA AWARDBODY1 VARCHAR2(8) Y VARCHAR2(1)[Y]
UI_HESA AWARDBODY2 VARCHAR2(8) Y VARCHAR2(1)[Y]
UI_HESA AWARDBODY3 VARCHAR2(8) Y VARCHAR2(1)[Y]
UI_HESA AWARDBODY4 VARCHAR2(8) Y VARCHAR2(1)[Y]
UI_HESA AWARDBODY5 VARCHAR2(8) Y VARCHAR2(1)[Y]
UI_HESA AWARDBODY6 VARCHAR2(8) Y VARCHAR2(1)[Y]
UI_HESA AWARDBODY7 VARCHAR2(8) Y VARCHAR2(1)[Y]
UI_HESA AWARDBODY8 VARCHAR2(8) Y VARCHAR2(1)[Y]

Back to top

The following columns have been dropped.

Table Name Column Name Type (Size) Nullable Description
ILP_TARGETS CREATED_BY_STAFF NUMBER(10) Y Identifier of the staff who created the target, if target created outside of Targetbank [FK=PEOPLE.PERSON_CODE].

Back to top

View changes:

The following views have been added:

  • EBS_DATAMINER_COLUMN_INFO

  • EBS_PU_SPECIAL_HESA_FIN

  • EBS_UIO_HESA_FINANCE

  • EBS_UI_HESA_DELIVORGANISATIONS

Back to top

The following columns have been added.

View Name Column Name
EBS_LEARNER_CONTACTS_SEARCH HAS_PERMISSION
EBS_LEARNER_ENROLMENTS PROG_PATHWAY_DATE
EBS_PEOPLE_PEOPLE_LINKS HAS_PERMISSION
EBS_PEOPLE_PEOPLE_LINKS_RCMS HAS_PERMISSION

Back to top

Service Pack 2 Changes

The following changes have been made for 4.37 Service Pack 2:

The following columns have been added.

Table Name Column Name Type (Size) Nullable Description
GRADUATE_OUTCOME_SURVEY XCAH01_1 Char(5) Y The Common Aggregation Hierarchy, first level grouping.
GRADUATE_OUTCOME_SURVEY XCAH01_2 Char(5) Y The Common Aggregation Hierarchy, first level grouping.
GRADUATE_OUTCOME_SURVEY XCAH01_3 Char(5) Y The Common Aggregation Hierarchy, first level grouping.
GRADUATE_OUTCOME_SURVEY XCAH01_4 Char(5) Y The Common Aggregation Hierarchy, first level grouping.
GRADUATE_OUTCOME_SURVEY XCAH01_5 Char(5) Y The Common Aggregation Hierarchy, first level grouping.
GRADUATE_OUTCOME_SURVEY XCAH03_1 Char(11) Y The Common Aggregation Hierarchy third level grouping.
GRADUATE_OUTCOME_SURVEY XCAH03_2 Char(11) Y The Common Aggregation Hierarchy third level grouping.
GRADUATE_OUTCOME_SURVEY XCAH03_3 Char(11) Y The Common Aggregation Hierarchy third level grouping.
GRADUATE_OUTCOME_SURVEY XCAH03_4 Char(11) Y The Common Aggregation Hierarchy third level grouping.
GRADUATE_OUTCOME_SURVEY XCAH03_5 Char(11) Y The Common Aggregation Hierarchy third level grouping.

Back to top